package com.example.coco.res;


import com.example.coco.model.Suggestion;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SuggestionMapper {

@Insert("insert into suggestion(userid,email,tel,body) values (#{userid},#{email},#{tel},#{body})")
    void addSuggestion(Suggestion suggestion);


@Select("select * from suggestion")
List<Suggestion> showsug();
}